package com.shzu.jwc.ty.dao;

import com.shzu.jwc.ty.bean.ViewTheoreticalExaminationAppointment;
import com.shzu.jwc.ty.bean.ViewTheoreticalExaminationAppointmentExample;
import java.util.List;
import org.apache.ibatis.annotations.Param;

public interface ViewTheoreticalExaminationAppointmentMapper {
    long countByExample(ViewTheoreticalExaminationAppointmentExample example);

    int deleteByExample(ViewTheoreticalExaminationAppointmentExample example);

    int insert(ViewTheoreticalExaminationAppointment record);

    int insertSelective(ViewTheoreticalExaminationAppointment record);

    List<ViewTheoreticalExaminationAppointment> selectByExampleWithBLOBs(ViewTheoreticalExaminationAppointmentExample example);

    List<ViewTheoreticalExaminationAppointment> selectByExample(ViewTheoreticalExaminationAppointmentExample example);

    int updateByExampleSelective(@Param("record") ViewTheoreticalExaminationAppointment record, @Param("example") ViewTheoreticalExaminationAppointmentExample example);

    int updateByExampleWithBLOBs(@Param("record") ViewTheoreticalExaminationAppointment record, @Param("example") ViewTheoreticalExaminationAppointmentExample example);

    int updateByExample(@Param("record") ViewTheoreticalExaminationAppointment record, @Param("example") ViewTheoreticalExaminationAppointmentExample example);
    
    List<ViewTheoreticalExaminationAppointment> selectbyYearID(@Param(value="startPos") Integer startPos,@Param(value="pageSize") Integer pageSize,@Param(value="systemYearId")Integer systemYearId);
    
    long getProductsCount(Integer systemYearId);
    
    long countselectknowledgescore(@Param("userStudentInfoYear") Integer userStudentInfoYear,@Param("userStudentInfoCollege") String userStudentInfoCollege,@Param("theoreticalExaminationId") Integer theoreticalExaminationId,@Param("systemYearId")Integer systemYearId);
    
    List<ViewTheoreticalExaminationAppointment> getselectknowledgescore(@Param("userStudentInfoYear") Integer userStudentInfoYear,@Param("userStudentInfoCollege") String userStudentInfoCollege,@Param("theoreticalExaminationId") Integer theoreticalExaminationId,@Param(value="startPos") Integer startPos,@Param(value="pageSize") Integer pageSize,@Param("systemYearId") Integer systemYearId);
}